load data
truncate                                       
into table CRST_PO_VENDOR_CONTACTS
fields terminated by "	"                      
trailing nullcols 
( VENDOR_CONTACT_ID       ,
  LAST_UPDATE_DATE        Date "YYYYMMDD HH24:MI:SS",
  LAST_UPDATED_BY         ,
  VENDOR_SITE_ID          ,
  LAST_UPDATE_LOGIN       ,
  CREATION_DATE           Date "YYYYMMDD HH24:MI:SS",
  CREATED_BY              ,
  INACTIVE_DATE           Date "YYYYMMDD HH24:MI:SS",
  FIRST_NAME              ,
  MIDDLE_NAME             ,
  LAST_NAME               ,
  PREFIX                  ,
  TITLE                   ,
  MAIL_STOP               ,
  AREA_CODE               ,
  PHONE                   ,
  ATTRIBUTE_CATEGORY      ,
  ATTRIBUTE1              ,
  ATTRIBUTE2              ,
  ATTRIBUTE3              ,
  ATTRIBUTE4              ,
  ATTRIBUTE5              ,
  ATTRIBUTE6              ,
  ATTRIBUTE7              ,
  ATTRIBUTE8              ,
  ATTRIBUTE9              ,
  ATTRIBUTE10             ,
  ATTRIBUTE11             ,
  ATTRIBUTE12             ,
  ATTRIBUTE13             ,
  ATTRIBUTE14             ,
  ATTRIBUTE15             ,
  REQUEST_ID              ,
  PROGRAM_APPLICATION_ID  ,
  PROGRAM_ID              ,
  PROGRAM_UPDATE_DATE     Date "YYYYMMDD HH24:MI:SS",
  CONTACT_NAME_ALT        ,
  FIRST_NAME_ALT          ,
  LAST_NAME_ALT           ,
  DEPARTMENT              
)
